--SELECT * FROM JobLetters
--DELETE FROM JobLetters
--INSERT INTO srv_lnk.nchr2008.dbo.JobLetters
SELECT top 5
Convert(int,right(id,7)) AS [ID],Convert(int,right(jobseekerid,7)) AS [UserID],[Title] AS [LetterTitle],[Body] AS [LetterContent],NULL AS [xAddDate],Convert(int,right(jobseekerid,7)) AS [CreatedUserId],[DateCreated] AS [CreatedDate],Convert(int,right(jobseekerid,7)) AS [UpdatedUserId],[LastUpdated] AS [UpdatedDate]FROM Forest.dbo.cat_coverletter
SELECT TOP 5 * FROM Forest.dbo.cat_coverletter
select top 5 * from srv_lnk.nchr2008.dbo.JobLetters
